2014-06-20 - RelNotes- 10102.700 - ROC - Air Shipment for GCP #DotNetReleases2014
Release Notes
10102.700 - ROC - Air Shipment for GCP
Admin Info
Purpose
|
To offer expedited shipping (air vs ocean) from overseas vendors to a small set of customers
for US sales orgs.
|
Release No#
|
001
|
Submitted on
|
06/20/2014
|
Submitted by
|
Vamshi
|
Source/Destination Systems
|
TFS/NEC DEV
|
Release Sent To
|
Bibin
|
Objects Created By
|
Vamshi
|
Objects Tested By
|
Vamshi
|
Transport and Technical Objects
Location Objects Name
\\10.115.101.93\sites\Deployments\ROCET-GCPAirFreight-06202014
|
- CustMastBulk.dtsx
- CustomerMaster.dtsx
- GCPMaintenance.aspx
- GCPMaintenance.aspx.js
- App_code/GenericClasses
- Global.asax
- ManageOrders.aspx
- ManageOrders.aspx.js
- App_Code/Orders.cs
- GCP Air Freight Script.sql
|
Release Notes
For Infrastructure
Please take backup of existing pages in DEV before replacing DEV page with TFS Pages.
Run the below attached Sql Script in DEV DB:
For Requestor
Interface Changes
- Displaying Expedited shidate in Manage order page for GCP orders.
- Additional field in GCP maintenance screen to insert data for Expedited freight.
Database Changes
- Added new column in the tables tblcustomermst,tblcustomermst_temp,tblcustomermst_validation,tbl_GcpMaintenance,tbl_OrderHeader to hold the Air Freight flag.
- USP_InsertGCP - To insert the Expedited Shipdate in GCP maintenance screen
- USP_getGCP - To get the GCP calender in the GCP maintenance screen
- USP_UPDATE_OrderHeader - To set the expedited flag for the order ,if the user selects the expedited shipdate.
- USP_GET_OUTBOUNDORDERS -To send a flag for the orders for which the users selected Expedited shipdate
- USP_GET_OrderDetails- Display data in manage orders page.
Test Notes
Test ID
|
Test Scenario
|
Expected Results
|
Actual Result
|
001
|
Run the customer Master package with the updated file which has expedited flag
|
The customer details should be inserted to the customer master table along with the expedited flag
|
As Expected
|
002
|
Create a ROC order for an expedited freightcustomer
|
If the product is GCP, both expedited andstandard dates are shown
|
As Expected
|
003
|
Select the expedited shipdate for the GCP order
|
A message will be displayed warning the user of the upcharge to the customer
|
As Expected
|
004
|
Create a ROC order a non-expedited freightcustomer
|
Only standard dates are shown for ship date
|
As Expected
|
005
|
Run the outbound package
|
The completed orders should be sent to SAP. Expedited flag should be sent for the orders which has the expeditedfreight customer and expedited shipdate
|
As Expected
|
Reference Document (Specifications or Production Support Break Fix)
Spec